28 Queries Logged

1. SELECT `data`
  FROM `nev6a_session`
  WHERE `session_id` = 'rph14kg66pu99tdjigfl55fko5'
2. DELETE
  FROM `nev6a_session`
  WHERE `time` < '1611322619'
3. SELECT folder AS type, element AS name, params
  FROM nev6a_extensions
  WHERE enabled >= 1
  AND type ='plugin'
  AND state >= 0
  AND access IN (1,1)
  ORDER BY ordering
4. SELECT extension_id AS id, element AS "option", params, enabled
  FROM nev6a_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_languages'
5. SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
  FROM nev6a_menu AS m
  LEFT JOIN nev6a_extensions AS e
  ON m.component_id = e.extension_id
  WHERE m.published = 1
  AND m.parent_id > 0
  AND m.client_id = 0
  ORDER BY m.lft
6. SELECT id, home, template, s.params
  FROM nev6a_template_styles as s
  LEFT JOIN nev6a_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
  WHERE s.client_id = 0
  AND e.enabled = 1
7. SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM nev6a_modules AS m
  LEFT JOIN nev6a_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN nev6a_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
  WHERE m.published = 1
  AND e.enabled = 1
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-01-22 13:51:59')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-01-22 13:51:59')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 0 OR mm.menuid <= 0)
  ORDER BY m.position, m.ordering
8. SELECT extension_id AS id, element AS "option", params, enabled
  FROM nev6a_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_content'
9. SELECT extension_id AS id, element AS "option", params, enabled
  FROM nev6a_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_search'
10. SELECT *
  FROM nev6a_languages
  WHERE published=1
  ORDER BY ordering ASC
11. SELECT extension_id AS id, element AS "option", params, enabled
  FROM nev6a_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_menus'
12. SELECT hits
  FROM nev6a_core_log_searches
  WHERE LOWER(search_term) = "{searchTerms}"
13. UPDATE nev6a_core_log_searches
  SET hits = (hits + 1)
  WHERE LOWER(search_term) = "{searchTerms}"
14. SELECT *
  FROM nev6a_hikashop_config
15. SHOW TABLES LIKE 'nev6a_falang_content'
16. SHOW TABLES LIKE 'nev6a_jf_content'
17. SELECT extension_id AS id, element AS "option", params, enabled
  FROM nev6a_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_users'
18. SELECT a.category_type AS section, a.category_id AS id, a.category_name AS title, a.category_created AS created , a.category_description AS text, "1" AS browsernav
  FROM nev6a_hikashop_category AS a
  WHERE a.category_published=1
  AND a.category_type IN ('product','manufacturer')
  AND (a.category_access = 'all' OR a.category_access LIKE '%,1,%')
  AND ((((a.category_name LIKE '%{searchTerms}%'))) OR (((a.category_description LIKE '%{searchTerms}%'))))
  ORDER BY a.category_modified DESC
  LIMIT 0, 50
19. SELECT category_id
  FROM nev6a_hikashop_category
  WHERE category_published=1
  AND category_type='product'
  AND (category_access = 'all' OR category_access LIKE '%,1,%')
20. 
  SET SQL_BIG_SELECTS=1
21. SELECT DISTINCT a.product_id AS id, a.product_name, a.product_created AS created , a.product_description, "1" AS browsernav, b.category_id as category_id
  FROM nev6a_hikashop_product AS a
  INNER JOIN nev6a_hikashop_product_category AS b
  ON a.product_id=b.product_id
  WHERE a.product_published=1
  AND a.product_type='main'
  AND (a.product_access = 'all' OR a.product_access LIKE '%,1,%')
  AND b.category_id IN (2,12,13,14)
  AND ((((a.product_name LIKE '%{searchTerms}%'))) OR (((a.product_description LIKE '%{searchTerms}%'))))
  GROUP BY (a.product_id)
  ORDER BY a.product_modified DESC
  LIMIT 0, 50
22. SELECT a.title, a.description AS text, "" AS created, "2" AS browsernav, a.id AS catid,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug
  FROM nev6a_categories AS a
  WHERE (a.title LIKE '%{searchTerms}%' OR a.description LIKE '%{searchTerms}%')
  AND a.published IN (1,2)
  AND a.extension = 'com_content'
  AND a.access IN (1,1)
  GROUP BY a.id
  ORDER BY a.title DESC
  LIMIT 0, 50
23. SELECT a.name AS title, '' AS created, a.con_position, a.misc,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, CONCAT_WS(',', a.name, a.con_position, a.misc) AS text,CONCAT_WS(' / ', 'Contacts', c.title) AS section,'2' AS browsernav
  FROM nev6a_contact_details AS a
  INNER JOIN nev6a_categories AS c
  ON c.id = a.catid
  WHERE (a.name LIKE '%{searchTerms}%'OR a.misc LIKE '%{searchTerms}%'OR a.con_position LIKE '%{searchTerms}%'OR a.address LIKE '%{searchTerms}%'OR a.suburb LIKE '%{searchTerms}%'OR a.state LIKE '%{searchTerms}%'OR a.country LIKE '%{searchTerms}%'OR a.postcode LIKE '%{searchTerms}%'OR a.telephone LIKE '%{searchTerms}%'OR a.fax LIKE '%{searchTerms}%')
  AND a.published IN (1,2)
  AND c.published=1
  AND a.access IN (1,1)
  AND c.access IN (1,1)
  GROUP BY a.id, a.con_position, a.misc
  ORDER BY a.name DESC
  LIMIT 0, 50
24. SELECT a.title AS title, a.metadesc, a.metakey, a.created AS created,CONCAT(a.introtext,a.fulltext) AS text,c.title AS section,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, '2' AS browsernav
  FROM nev6a_content AS a
  INNER JOIN nev6a_categories AS c
  ON c.id=a.catid
  WHERE ((a.title LIKE '%{searchTerms}%' OR a.introtext LIKE '%{searchTerms}%' OR a.fulltext LIKE '%{searchTerms}%' OR a.metakey LIKE '%{searchTerms}%' OR a.metadesc LIKE '%{searchTerms}%'))
  AND a.state=1
  AND c.published = 1
  AND a.access IN (1,1)
  AND c.access IN (1,1)
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-22 13:51:59')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-22 13:51:59')
  GROUP BY a.id, a.title, a.metadesc, a.metakey, a.created, a.introtext, a.fulltext, c.title, a.alias, c.alias, c.id
  ORDER BY a.created DESC
  LIMIT 0, 50
25. SELECT a.title AS title, a.metadesc, a.metakey, a.created AS created, CONCAT(a.introtext,a.fulltext) AS text,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, c.title AS section, '2' AS browsernav
  FROM nev6a_content AS a
  INNER JOIN nev6a_categories AS c
  ON c.id=a.catid
  AND c.access IN (1,1)
  WHERE ((a.title LIKE '%{searchTerms}%' OR a.introtext LIKE '%{searchTerms}%' OR a.fulltext LIKE '%{searchTerms}%' OR a.metakey LIKE '%{searchTerms}%' OR a.metadesc LIKE '%{searchTerms}%'))
  AND a.state = 2
  AND c.published = 1
  AND a.access IN (1,1)
  AND c.access IN (1,1)
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-22 13:51:59')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-22 13:51:59')
  ORDER BY a.created DESC
  LIMIT 0, 50
26. SELECT a.name AS title, "" AS created, a.link AS text,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,CONCAT_WS(' / ', 'Newsfeeds', c.title) AS section,"1" AS browsernav
  FROM nev6a_newsfeeds AS a
  INNER JOIN nev6a_categories as c
  ON c.id = a.catid
  WHERE ((a.name LIKE '%{searchTerms}%' OR a.link LIKE '%{searchTerms}%'))
  AND a.published IN (1,2)
  AND c.published = 1
  AND c.access IN (1,1)
  ORDER BY a.name ASC
  LIMIT 0, 50
27. SELECT a.title AS title, a.description AS text, a.created AS created, a.url,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, CONCAT_WS(' / ', 'Search - Weblinks', c.title) AS section, '1' AS browsernav
  FROM nev6a_weblinks AS a
  INNER JOIN nev6a_categories AS c
  ON c.id = a.catid
  WHERE ((a.url LIKE '%{searchTerms}%' OR a.description LIKE '%{searchTerms}%' OR a.title LIKE '%{searchTerms}%'))
  AND a.state in (1,2)
  AND c.published=1
  AND c.access IN (1,1)
  ORDER BY a.created DESC
  LIMIT 0, 50
28. UPDATE `nev6a_session`
  SET `data` = '__default|a:7:{s:15:\"session.counter\";i:48;s:19:\"session.timer.start\";i:1611322743;s:18:\"session.timer.last\";i:1611323514;s:17:\"session.timer.now\";i:1611323519;s:22:\"session.client.browser\";s:129:\"Mozilla/5.0 (compatible; NLNZ_IAHarvester2021/3.3.0 +https://natlib.govt.nz/publishers-
  and-authors/web-harvesting/domain-harvest)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}' , `time` = '1611323520'
  WHERE `session_id` = 'rph14kg66pu99tdjigfl55fko5'

24 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 5 × SELECT extension_id AS id, element AS "option", params, enabled
  FROM nev6a_extensions
2. 1 × SELECT a.name AS title, '' AS created, a.con_position, a.misc,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, CONCAT_WS(',', a.name, a.con_position, a.misc) AS text,CONCAT_WS(' / ', 'Contacts', c.title) AS section,'2' AS browsernav
  FROM nev6a_contact_details AS a
  INNER JOIN nev6a_categories AS c
  ON c.id = a.catid
3. 1 × SELECT a.title, a.description AS text, "" AS created, "2" AS browsernav, a.id AS catid,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug
  FROM nev6a_categories AS a
4. 1 × SELECT a.title AS title, a.metadesc, a.metakey, a.created AS created,CONCAT(a.introtext,a.fulltext) AS text,c.title AS section,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, '2' AS browsernav
  FROM nev6a_content AS a
  INNER JOIN nev6a_categories AS c
  ON c.id=a.catid
5. 1 × SELECT DISTINCT a.product_id AS id, a.product_name, a.product_created AS created , a.product_description, "1" AS browsernav, b.category_id as category_id
  FROM nev6a_hikashop_product AS a
  INNER JOIN nev6a_hikashop_product_category AS b
  ON a.product_id=b.product_id
6. 1 × SELECT a.title AS title, a.metadesc, a.metakey, a.created AS created, CONCAT(a.introtext,a.fulltext) AS text,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, c.title AS section, '2' AS browsernav
  FROM nev6a_content AS a
  INNER JOIN nev6a_categories AS c
  ON c.id=a.catid
  AND c.access IN (1,1)
7. 1 × SELECT a.title AS title, a.description AS text, a.created AS created, a.url,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, CONCAT_WS(' / ', 'Search - Weblinks', c.title) AS section, '1' AS browsernav
  FROM nev6a_weblinks AS a
  INNER JOIN nev6a_categories AS c
  ON c.id = a.catid
8. 1 × SELECT a.name AS title, "" AS created, a.link AS text,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,CONCAT_WS(' / ', 'Newsfeeds', c.title) AS section,"1" AS browsernav
  FROM nev6a_newsfeeds AS a
  INNER JOIN nev6a_categories as c
  ON c.id = a.catid
9. 1 × SELECT category_id
  FROM nev6a_hikashop_category
10. 1 × SELECT *
  FROM nev6a_hikashop_confi
11. 1 × SELECT id, home, template, s.params
  FROM nev6a_template_styles as s
  LEFT JOIN nev6a_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
12. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
  FROM nev6a_menu AS m
  LEFT JOIN nev6a_extensions AS e
  ON m.component_id = e.extension_id
13. 1 × SELECT folder AS type, element AS name, params
  FROM nev6a_extensions
14. 1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM nev6a_modules AS m
  LEFT JOIN nev6a_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN nev6a_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
15. 1 × SELECT *
  FROM nev6a_languages
16. 1 × SELECT `data`
  FROM `nev6a_session`
17. 1 × SELECT hits
  FROM nev6a_core_log_searches
18. 1 × SELECT a.category_type AS section, a.category_id AS id, a.category_name AS title, a.category_created AS created , a.category_description AS text, "1" AS browsernav
  FROM nev6a_hikashop_category AS a

OTHER Tables:

1. 1 ×
  SET SQL_BIG_SELECTS=
2. 1 × UPDATE `nev6a_session`
  SET `data` = '__default|a:7:{s:15:\"session.counter\";i:48;s:19:\"session.timer.start\";i:1611322743;s:18:\"session.timer.last\";i:1611323514;s:17:\"session.timer.now\";i:1611323519;s:22:\"session.client.browser\";s:129:\"Mozilla/5.0 (compatible; NLNZ_IAHarvester2021/3.3.0 +https://natlib.govt.nz/publishers-
  and-authors/web-harvesting/domain-harvest)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}' , `time` = '1611323520'
3. 1 × SHOW TABLES LIKE 'nev6a_jf_content
4. 1 × SHOW TABLES LIKE 'nev6a_falang_content
5. 1 × UPDATE nev6a_core_log_searches
  SET hits = (hits + 1)
6. 1 × DELETE
  FROM `nev6a_session`